//FBA明细导出
export const fbaItemExportSheet = [
  {
    group: '单据信息',
    columns: [
      { key: 'shopName', name: '店铺', keyType: '1' },
      { key: 'warehouseName', name: '发货仓', keyType: '1' },
      { key: 'billNo', name: '发货单号', keyType: '1' },
      { key: 'shipmentId', name: 'FBA货件号', keyType: '1' },
      { key: 'status', name: '货件状态', keyType: '1' },
      { key: 'centerId', name: 'CenterId', keyType: '1' },
      { key: 'shipToAddress.countryCode', name: '收货国家', keyType: '1' },
      { key: 'createUname', name: '创建人', keyType: '1' },
      { key: 'gmtCreate', name: '创建时间', keyType: '1' },
      { key: 'gmtSubmit', name: '提交处理时间', keyType: '1' },
      { key: 'urgent', name: '是否加急', keyType: '1' },
    ],
  },
  {
    group: '商品信息',
    columns: [
      { key: 'productImg', name: '图片', keyType: '2' },
      { key: 'msku', name: 'MSKU', keyType: '1' },
      { key: 'sku', name: 'SKU', keyType: '1' },
      { key: 'spu', name: 'SPU', keyType: '1' },
      { key: 'cateName', name: '类目', keyType: '1' },
      { key: 'productSpecs', name: '规格名', keyType: '1' },
      { key: 'packageSku', name: '包装SKU', keyType: '1' },
      { key: 'packageName', name: '包装名称', keyType: '1' },
      { key: 'asin', name: 'ASIN', keyType: '1' },
      { key: 'asinLink', name: 'listing链接', keyType: '1' },
      { key: 'productName', name: '商品标题', keyType: '1' },
      { key: 'sellingPrice', name: '售价(币种)', keyType: '1' },
    ],
  },
  {
    group: '报关信息',
    columns: [
      { key: 'declareName', name: '报关中文名', keyType: '1' },
      { key: 'declareEnName', name: '报关英文名', keyType: '1' },
      { key: 'declareAmount', name: '报关单价(币种)', keyType: '1' },
      { key: 'declareNum', name: '报关数量', keyType: '1' },
      { key: 'declareWeight', name: '报关重量', keyType: '1', tip: '报关重量是指单件产品的重量' },
      { key: 'declareNo', name: '海关编号', keyType: '1' },
    ],
  },
  {
    group: '单据明细信息',
    columns: [
      { key: 'boxNo', name: '箱号', keyType: '1' },
      { key: 'realNum', name: '发货数', keyType: '1' },
      { key: 'receiveNum', name: '入库数', keyType: '1' },
      { key: 'differentNum', name: '差异数', keyType: '1' },
      { key: 'price', name: '出库单价', keyType: '1' },
      { key: 'packagingPrice', name: '包装单价', keyType: '1' },
      { key: 'productValue', name: '产品货值', keyType: '1', tip: '产品货值=产品出库成本*发货数量' },
      { key: 'packagingValue', name: '包装货值', keyType: '1', tip: '包装货值=出库的包装成本*发货数量' },
      { key: 'deliveryValue', name: '发货总货值', keyType: '1', tip: '发货总货值=(产品出库成本*发货数量)+(出库的包装成本*发货数量)' },
      { key: 'receiveValue', name: '入库总货值', keyType: '1', tip: '入库总货值=(产品出库成本*入库数量)+(出库的包装成本*入库数量)' },
      { key: 'shipFee', name: '运费', keyType: '1' },
    ],
  },
]
//FBA货件导出
export const fbaExportSheet = [
  {
    group: '',
    columns: [
      { key: 'shopName', name: '店铺', keyType: '1' },
      { key: 'warehouseName', name: '发货仓', keyType: '1' },
      { key: 'billNo', name: '发货单号', keyType: '1' },
      { key: 'shipmentId', name: 'FBA货件号', keyType: '1' },
      { key: 'status', name: '货件状态', keyType: '1' },
      { key: 'centerId', name: 'CenterId', keyType: '1' },
      { key: 'shipToAddress.countryCode', name: '收货国家', keyType: '1' },
      { key: 'shipToAddress.stateOrProvinceCode', name: '收货省州', keyType: '1' },
      { key: 'shipToAddress.city', name: '收货城市', keyType: '1' },
      { key: 'realNum', name: '发货数', keyType: '1' },
      { key: 'receiveNum', name: '入库数', keyType: '1' },
      { key: 'differentNum', name: '差异数', keyType: '1' },
      { key: 'shipFee', name: '运费', keyType: '1' },
      { key: 'productValue', name: '产品货值', keyType: '1', tip: '产品货值=产品出库成本*发货数量' },
      { key: 'packagingValue', name: '包装货值', keyType: '1', tip: '包装货值=出库的包装成本*发货数量' },
      { key: 'deliveryValue', name: '发货总货值', keyType: '1', tip: '发货总货值=(产品出库成本*发货数量)+(出库的包装成本*发货数量)' },
      { key: 'receiveValue', name: '入库总货值', keyType: '1', tip: '入库总货值=(产品出库成本*入库数量)+(出库的包装成本*入库数量)' },
      { key: 'boxNum', name: '箱数', keyType: '1' },
      { key: 'createUname', name: '创建人', keyType: '1' },
      { key: 'gmtCreate', name: '创建时间', keyType: '1' },
      { key: 'gmtSubmit', name: '提交处理时间', keyType: '1' },
      { key: 'urgent', name: '是否加急', keyType: '1' },
    ],
  },
]
//FBA装箱信息导出
export const fbaBoxExportSheet = [
  {
    group: '单据信息',
    columns: [
      { key: 'shopName', name: '店铺', keyType: '1' },
      { key: 'warehouseName', name: '发货仓', keyType: '1' },
      { key: 'billNo', name: '发货单号', keyType: '1' },
      { key: 'shipmentId', name: 'FBA货件号', keyType: '1' },
      { key: 'status', name: '货件状态', keyType: '1' },
      { key: 'centerId', name: 'CenterId', keyType: '1' },
      { key: 'shipToAddress.countryCode', name: '收货国家', keyType: '1' },
      { key: 'createUname', name: '创建人', keyType: '1' },
      { key: 'gmtCreate', name: '创建时间', keyType: '1' },
      { key: 'gmtSubmit', name: '提交处理时间', keyType: '1' },
      { key: 'urgent', name: '是否加急', keyType: '1' },
    ],
  },
  {
    group: '装箱信息',
    columns: [
      { key: 'boxNo', name: '箱号', keyType: '1' },
      { key: 'weight', name: '重量（kg）', keyType: '1' },
      { key: 'weight2', name: '重量（bl）', keyType: '1' },
      { key: 'length', name: '体积（cm）', keyType: '1' },
      { key: 'length2', name: '体积（in）', keyType: '1' },
      { key: 'boxNum', name: 'SKU数量', keyType: '1' },
    ],
  },
  {
    group: '物流信息',
    columns: [
      { key: 'logisticName', name: '物流商', keyType: '1' },
      { key: 'logisticChannelName', name: '物流渠道', keyType: '1' },
      { key: 'logisticsWaybillNumber', name: '运单号', keyType: '1' },
      { key: 'logisticsTrackNumber', name: '跟踪号', keyType: '1' },
      { key: 'shipFee', name: '预估运费', keyType: '1' },
      { key: 'realShipFee', name: '实际运费', keyType: '1' },
    ],
  },
]
//结算报告明细
export const settlementItemSheet = [
  {
    group: '',
    columns: [
      { key: 'shop_name', name: '店铺', keyType: '1', checked: true },
      { key: 'settlement_id', name: '结算ID', keyType: '1', checked: true },
      { key: 'amount', name: '金额', keyType: '1', checked: true },
      { key: 'currency', name: '币种', keyType: '1', checked: true },
      { key: 'cny_amount', name: '人民币', keyType: '1', checked: true },
      { key: 'usd_amount', name: '美元', keyType: '1', checked: true },
      { key: 'settlement_start_date', name: '开始时间', keyType: '1', checked: true },
      { key: 'settlement_end_date', name: '结束时间', keyType: '1', checked: true },
      { key: 'posted_Date_Time', name: '发布时间', keyType: '1', checked: true },
      { key: 'salesman_name', name: '运营', keyType: '1', checked: true },
      { key: 'order_Id', name: '订单号', keyType: '1', checked: true },
      { key: 'order_Item_Code', name: '订单itemCode', keyType: '1', checked: true },
      { key: 'fulfillment_Id', name: '履约方式', keyType: '1', checked: true },
      { key: 'sku', name: 'SellerSku', keyType: '1', checked: true },
      { key: 'product_sku', name: '产品SKU', keyType: '1', checked: true },
      { key: 'asin', name: 'ASIN', keyType: '1', checked: true },
      { key: 'transaction_type', name: '交易类型', keyType: '1', checked: true },
      { key: 'amount_Type', name: '金额类型', keyType: '1', checked: true },
      { key: 'amount_Description', name: '金额说明', keyType: '1', checked: true },
      { key: 'quantity_purchased', name: '商品数量', keyType: '1', checked: true },
      { key: 'sum_type_name', name: '汇总类型', keyType: '1', checked: true },
    ],
  },
]
// 结算报告-按运营汇总
export const settlementItemSheetByUser = [
  {
    group: '',
    columns: [
      { key: 'shop_name', name: '店铺', keyType: '1', checked: true },
      { key: 'salesman_name', name: '运营', keyType: '1', checked: true },
      { key: 'dept_name', name: '部门', keyType: '1', checked: true },
      { key: 'marketplace_id', name: '站点', keyType: '1', checked: true },
      { key: 'month', name: '月份', keyType: '1', checked: true },
      { key: 'currency', name: '币种', keyType: '1', checked: true },
      { key: 'TYPE_SALES_AMOUNT', name: '销售金额', keyType: '1', checked: true },
      { key: 'TYPE_LAST_RESERVED_AMOUNT_V2', name: '上月预留金', keyType: '1', checked: true },
      { key: 'TYPE_THIS_RESERVED_AMOUNT_V2', name: '本月预留金', keyType: '1', checked: true },
      { key: 'TYPE_RETURN_AMOUNT', name: '退货金额', keyType: '1', checked: true },
      { key: 'TYPE_PREFERENTIAL_AMOUNT', name: '优惠金额', keyType: '1', checked: true },
      { key: 'TYPE_TRANSACTION_FEE', name: '交易费', keyType: '1', checked: true },
      { key: 'TYPE_TRANSPORTATION_EXPENSES', name: '运费', keyType: '1', checked: true },
      { key: 'TYPE_ADVERTISING_EXPENSES', name: '广告费', keyType: '1', checked: true },
      { key: 'TYPE_SECKILL_FEE', name: '秒杀费', keyType: '1', checked: true },
      { key: 'TYPE_SUBSCRIPTION_FEE', name: '订阅费', keyType: '1', checked: true },
      { key: 'TYPE_MONTHLY_RENT', name: '月租费', keyType: '1', checked: true },
      { key: 'TYPE_COMMENT_FEE', name: '评论费', keyType: '1', checked: true },
      { key: 'TYPE_CASH_WITHDRAWAL_AMOUNT', name: '税费', keyType: '1', checked: true },
      { key: 'TYPE_OTHER_EXPENSES', name: '其它费用', keyType: '1', checked: true },
      { key: 'TYPE_PROFIT', name: '提现金额', keyType: '1', checked: true },
      { key: 'cny_rate', name: 'CNY汇率', keyType: '1', checked: true },
      { key: 'usd_rate', name: 'USD汇率', keyType: '1', checked: true },
      { key: 'cny_amount', name: '人民币', keyType: '1', checked: true },
      { key: 'usd_amount', name: '美元', keyType: '1', checked: true },
    ],
  },
]
// 采购入库单
export const exportReceiptOrderSheet = [
  {
    group: '',
    columns: [
      { key: 'billNo', name: '入库单号', keyType: '1', checked: true },
      { key: 'deliveryNo', name: '交货单号', keyType: '1', checked: true },
      { key: 'purchaseNo', name: '采购单号', keyType: '1', checked: true },
      { key: 'warehouseName', name: '入库仓', keyType: '1', checked: true },
      { key: 'shopName', name: '店铺', keyType: '1', checked: true },
      { key: 'productImg', name: '图片', keyType: '2', checked: true },
      { key: 'productName', name: '产品名称', keyType: '1', checked: true },
      { key: 'sku', name: 'SKU', keyType: '1', checked: true },
      { key: 'cateName', name: '类目', keyType: '1', checked: true },
      { key: 'productSpecs', name: 'SKU规格', keyType: '1', checked: true },
      { key: 'msku', name: 'MSKU', keyType: '1', checked: true },
      { key: 'warehouseStayAmt', name: '待入库数', keyType: '1', checked: true },
      { key: 'warehouseRealAmt', name: '已入库数', keyType: '1', checked: true },
      { key: 'warehouseReturnAmt', name: '退回数量', keyType: '1', checked: true },
      { key: 'unitCosts', name: '单件成本', keyType: '1', checked: true },
      { key: 'inventoryValue', name: '入库货值', keyType: '1', checked: true },
      { key: 'locationCode', name: '货位', keyType: '1', checked: true },
      { key: 'createUname', name: '提交人', keyType: '1', checked: true },
      { key: 'gmtCreate', name: '提交时间', keyType: '1', checked: true },
      { key: 'signUname', name: '入库人', keyType: '1', checked: true },
      { key: 'gmtSign', name: '入库时间', keyType: '1', checked: true },
    ],
  },
]
